valign pada table di asp.net core
<td style="vertical-align: middle">Test</td>
vertical-align : middle = valign="center"
berusaha untuk berbagi
Kamis, 18 April 2024 Sunarto 0
<td style="vertical-align: middle">Test</td>
vertical-align : middle = valign="center"
Selasa, 16 April 2024 Sunarto 0
double CPLPersen= 30.10;
TempData["CPLPersen"] = CPLPersen.ToString("#,##0.00");
Jumat, 12 April 2024 Sunarto 0
perintah IIF dalam MS-SQL
select iif(praktikum is null,'Kuliah','Praktikum') as jenisKuliah from kuliah
artinya jika field berisi null maka jenisKuliah berisi kata Kuliah, sebaliknya jika tidak null maka berisi Praktikum
Install NuGet
Project - Manage NuGet
MySQL Data (Install)
Test Koneksi
using MySql.Data.MySqlClient;
MySql.Data.MySqlClient.MySqlConnection myConnection;
string myConnectionString;
myConnectionString = "server=server;uid=user;pwd=password;database=database";
try
{
myConnection = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
myConnection.Open();
MySqlCommand myCommand = new MySqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = @"SELECT * FROM GudangWHERE field = @param;";
myCommand.Parameters.AddWithValue("@param", "123445");
using var myReader = myCommand.ExecuteReader();
{
while (myReader.Read())
{
TempData["Nama"]= myReader.GetString("nama");
}
}
myConnection.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
TempData["Nama"]= ex.Message;
}
Kamis, 11 April 2024 Sunarto 0
ALTER TABLE tabel123
ADD NewColumn1 UNIQUEIDENTIFIER
CONSTRAINT DF_T_Account_NewColumn1 DEFAULT (newid()) WITH VALUES